Mega Code Archive
User Privilege
1) Add CASCADE after the users name in the DROP USER statement
2) Alter user to change the password
3) Assign CONNECT and RESOURCE Roles
4) Assign object privileges to roles
5) Assign Role to User
6) Change the password for the current user using the PASSWORD command
7) Changing a Users Password Using the ALTER USER statement
8) Checking Object Privileges Granted to a Role
9) Checking Roles Granted to a User
10) Checking System Privileges Granted to a Role
11) Create a synonym for a view
12) Create user and assign password
13) Create user and grant permission
14) CREATE USER userName IDENTIFIED BY password and grant permission
15) Create User Utility
16) Create user with storage quota
17) Create user with temporary tablespace, quota and default tablespace
18) Creates a user named henry and specifies a default and temporary tablespace
19) Creates a user named jason with a password of pass
20) Creating a public synonym
21) Creating a synonym for a table
22) Creating a User
23) Creating Roles
24) Default Roles
25) Describe a synonym
26) Display current user
27) Drop Role
28) Drop the user if it exists
29) Dropping a public synonym
30) Dropping a Role
31) Dropping a synonym
32) Get user name from all_users
33) Grant a privilege to all users by granting to PUBLIC
34) Grant a procedure to public and then execute it
35) Grant administer database trigger to userName
36) Grant all possible permissions
37) Grant connect and resource permission to a user
38) Grant connect permission to a user
39) Grant connect to permission to all name in a table
40) Grant create any context to userName
41) Grant CREATE SYNONYM, CREATE VIEW, CREATE DATABASE LINK, CREATE PUBLIC SYNONYM, DROP PUBLIC SYNONYM
42) Grant execute on dbms_rls to userName
43) Grant select on tableName to userName
44) Grant with admin option
45) Granting Object Privileges to a User
46) Granting Privileges to Roles
47) Granting Roles to a User
48) Granting System Privileges to a User
49) Object Privileges
50) Output session roles from procedure
51) Procedure for current user
52) Public Synonyms
53) Query a table by selecting its synonym
54) Query user granted roles
55) Regina and Kristen are manager level users
56) REVOKE CREATE TABLE, CREATE CLUSTER, CREATE SYNONYM, CREATE VIEW, CREATE SEQUENCE, CREATE DATABASE LINK FROM CONNECT
57) Revoke Permissions
58) Revoke Permissions with Cascade
59) Revoke system privileges from a user using REVOKE
60) Revoking a Role
61) Revoking Object Privileges
62) Revoking Privileges from a Role
63) Rich and Brad are maintenance level users
64) Roles
65) Seeing SYNONYM in the Oracle data dictionary
66) Synonyms
67) System Privileges
68) The EXECUTE ANY PROCEDURE can then be granted to another user
69) To connect to the database a user must be granted the permission to create a session, which is the CREATE SESSION system pr
70) Unassign Role
71) Unassign Role from User
72) Unlocking (or locking) accounts
73) Use the GRANT option to enable a user to grant a privilege to another user
74) Use WITH ADMIN OPTION to enable a user to grant a privilege to another user
75) User space